CREATE TABLE [dbo].[Tb_STecnicos]
(
[IDTecnico] [int] NOT NULL IDENTITY(1, 1),
[ApellidoyNombre] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IDAInformatica] [int] NULL,
[EMail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Tb_STecnicos] ADD CONSTRAINT [PK_Tb_STecnicos] PRIMARY KEY CLUSTERED  ([IDTecnico]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Tb_STecnicos] ADD CONSTRAINT [FK_Tb_STecnicos_Tb_SAreasInformaticas1] FOREIGN KEY ([IDAInformatica]) REFERENCES [dbo].[Tb_SAreasInformaticas] ([IDArea])
GO
